<?php 
   require_once('system/dbConn.php');
   connect();
   /*获取视频类别列表*/
   $id=$_GET['id'];
   $sql_vt='select * from videotype';
   $vt_list=fetch_array($sql_vt);
   /*获取点击排行列表*/
   $sql_hits="select * from videos where tid=".$id." order by hittinmes desc limit 0,4";
   $hits_list=fetch_array($sql_hits);
   /*获取视频信息*/
   $v_list=array();
   foreach ($vt_list as $one)
   {
       $sql="select * from videos where tid=".$one['tid']." order by vid desc limit 0,6";
       $vlist=array();
       $vlist['tid']=$one['tid'];
       $vlist['typename']=$one['typename'];
       $vlist['list']=fetch_array($sql);
       $v_list[]=$vlist;
   }
   $sql='select * from videotype where tid='.$id.'';
   $list=fetch_array($sql);
   $video_list=array();
   foreach ($list as $two)
   {
       $sql="select * from videos where tid=".$two['tid']." ";
       $videolist=array();
       $videolist['tid']=$two['tid'];
       $videolist['typename']=$two['typename'];
       $videolist['list']=fetch_array($sql);
       $video_list[]=$videolist;
   }
?>
<!DOCTYPE html>
<html lang="zh-cn">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" href="../../favicon.ico">

    <title>视频信息管理系统</title>

    <!-- Bootstrap core CSS -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="assets/css/offcanvas.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
    <!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
    <!--[if lt IE 9]>
    <script src="assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
    <script src="assets/js/ie-emulation-modes-warning.js"></script>

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
    <script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>

<body>
<nav class="navbar navbar-fixed-top navbar-inverse">
  <div class="container-fluid">
    <!-- Brand and toggle get grouped for better mobile display -->
    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
     
    </div>

    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav">
        <li><a href="index.php">首页 <span class="sr-only">(current)</span></a></li>
        <?php 
           foreach ($v_list as $one)
           {
             echo '<li><a href="list.php?id='.$one['tid'].'">'.$one['typename'].'</a></li>';
           }
        ?>
        <!-- <li><a href="list.php?tid=1">电影</a></li>
        <li><a href="list.php?tid=2">电视剧</a></li>
        <li><a href="list.php?tid=3">动画片</a></li>
        <li class="dropdown">
          <a href="list.php?tid=4" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">原创 <span class="caret"></span></a>
          <ul class="dropdown-menu">
            <li><a href="#">喜剧</a></li>
            <li><a href="#">科幻</a></li>
            <li><a href="#">教育</a></li>
            <li role="separator" class="divider"></li>
            <li><a href="#">其他</a></li>
          </ul>
        </li> -->
      </ul>
      <form class="navbar-form navbar-left" role="search" action="search.html">
        <div class="form-group">
          <input type="text" class="form-control" placeholder="Search">
        </div>
        <button type="submit" class="btn btn-default">搜索</button>
      </form>
      <ul class="nav navbar-nav navbar-right">
        <li class="active"><a href="#" >欢迎访问本网站</a></li>
        <li><a href="#" data-toggle="modal" data-target="#myModal1">登录</a></li>
        <li><a href="#" data-toggle="modal" data-target="#myModal">注册</a></li>
      
      </ul>
    </div><!-- /.navbar-collapse -->
  </div><!-- /.container-fluid -->
</nav>

<!-- /.navbar -->


<div class="container">

    <div class="row row-offcanvas row-offcanvas-right">

        <div class="col-xs-12 col-sm-9">


            <div class="row text-center">
            <?php  
                foreach ($video_list as $vt){
            ?>
            <div class="col-xs-12 col-lg-12 mlist">
                <h2><?php echo $vt['typename'];?></h2>
                    <ul class="list-inline row text-center">
                        <?php 
                            foreach ($vt['list'] as $one)
                            {
                                echo '<li class="col-xs-6 col-lg-2">
                                    <img src="images/'.$one['pic'].'" class="responsive img-thumbnail"/>
                                    <p><a href="show.php?id='.$one['vid'].'">'.$one['videoname'].'</a></p>
                                      </li>';
                            }
                        ?>
                    </ul>
                    <nav class="text-center">
                        <ul class="pagination">
                            <li>
                                <a href="#" aria-label="Previous">
                                    <span aria-hidden="true">&laquo;</span>
                                </a>
                            </li>
                            <li><a href="#">1</a></li>
                            <li><a href="#">2</a></li>
                            <li><a href="#">3</a></li>
                            <li><a href="#">4</a></li>
                            <li><a href="#">5</a></li>
                            <li>
                                <a href="#" aria-label="Next">
                                    <span aria-hidden="true">&raquo;</span>
                                </a>
                            </li>
                        </ul>
                    </nav>

            </div>
            <?php
                }
            ?>
                    <!-- <ul class="list-inline row text-center">
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/5555.png" class="responsive img-thumbnail"/>
                            <p><a href="show.php">老炮儿</a></p>
                        </li>
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/speed.jpg" class="responsive img-thumbnail"/>
                            <p><a href="show.php">速度与激情</a></p>
                        </li>
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/special forces.jpg" class="responsive img-thumbnail"/>
                            <p><a href="show.php">特种部队2（全面反击）</a></p>
                        </li>
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/forrest gump.jpg" class="responsive img-thumbnail"/>
                            <p><a href="show.php">阿甘正传</a></p>
                        </li>
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/pianist.jpg" class="responsive img-thumbnail"/>
                            <p><a href="show.php">海上钢琴师</a></p>
                        </li>
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/The Shawshank Redemption.jpg" class="responsive img-thumbnail"/>
                            <p><a href="show.php">肖申克的救赎</a></p>
                        </li>
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/a dogs story.jpg" class="responsive img-thumbnail"/>
                            <p><a href="show.php">忠犬八公的故事</a></p>
                        </li>
                        <li class="col-xs-6 col-lg-3">
                            <img src="images/happiness.jpeg" class="responsive img-thumbnail"/>
                            <p><a href="show.php">当幸福来敲门</a></p>
                        </li>
                    </ul> 

                </div>-->
                <!--/.col-xs-6.col-lg-4-->

            </div>
            <!--/row-->
        </div>
        <!--/.col-xs-12.col-sm-9-->
        
        <div class="col-xs-6 col-sm-3 sidebar-offcanvas" id="sidebar">
            <div class="list-group text-center">
                <h2 style="color:white;" >排行</h2>
                <ul class="list-inline row text-center">
                    <?php 
                        foreach ($hits_list as $one)
                        {
                            echo '<li class="col-xs-12 col-lg-6">
                                    <img src="images/'.$one['pic'].'" class="responsive img-thumbnail"/>
                                    <p><a href="show.php?id='.$one['vid'].'">'.$one['videoname'].'</a>
                                    </p>
                                  </li>';
                        }
                     ?>
        <!-- <div class="col-xs-6 col-sm-3 sidebar-offcanvas">
            <div class="list-group text-center" id="sidebar">
                <h2 style="color:white;">下载排行</h2>
                <ul class="list-inline row text-center">
                    <li class="col-xs-12 col-lg-6">
                        <img src="images/pianist.jpg" class="responsive img-thumbnail"/>
                        <p><a href="show.php">海上钢琴师</a></p>
                    </li>
                    <li class="col-xs-12 col-lg-6">
                        <img src="images/happiness.jpeg" class="responsive img-thumbnail"/>
                        <p><a href="show.php">当幸福来敲门</a></p>
                    </li>
                    <li class="col-xs-12 col-lg-6">
                        <img src="images/forrest gump.jpg" class="responsive img-thumbnail"/>
                        <p><a href="show.php">阿甘正传</a></p>
                    </li>
                    <li class="col-xs-12 col-lg-6">
                        <img src="images/a dogs story.jpg" class="responsive img-thumbnail"/>
                        <p><a href="show.php">忠犬八公的故事</a></p>
                    </li>-->

                </ul>
            </div>
        </div> 
        <!--/.sidebar-offcanvas-->
    </div>
    <!--/row-->

    

</div>
<!--/.container-->
<hr>

    <footer>
        <p>&copy; 魏莹悦 </p>
    </footer>

<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
<script src="assets/js/ie10-viewport-bug-workaround.js"></script>

<script src="offcanvas.js"></script>
</body>
</html>